This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
~Samuel Nimfookonyettu 12.Jan.04 04:54 PM a Web browser Domino Designer 6.0.3 Windows XP
I'm trying to experiment using ODBC. After they installed SQL server on my local machine, I could see the local database fine using Microsoft SQL Enterprise Manager v8.0. I can loop through the records using the Microsoft product without a problem.
In LotusScript, however, I'm getting a Notes system dump in the IBM_TECHNICAL_SUPPORT subdirectory every time I run the code. It happens on a specific ID in the file although the ID changes if I retrieve a different range of items.
The 1MB file has some fatal errors about "Exception code: c0000005 (ACCESS_VIOLATION)" although I can access the record from the MS product.
The code at this point has been whacked down to something bare bones and even that's getting the error. The loop that it dies in is shown below. Nothing fancy here! It's straight from the book.
Do
rc = result.NextRow
ID = result.GetValue("id", id)
Print "(4) ID=" & ID
Loop Until result.IsEndOfData
I've tested the rc variable and there's nothing unusual there -- it's -1 (true) for all of the records. It gets down to a particular ID (116783) and then immediately dies. I'm able to access this record and the next from the MS tool.
Any suggestions as to what I should be checking for?